create_agro_sample_management_table = [
    'CREATE TABLE AgroSample '
    '('
        'data_id int primary key auto_increment,'
        'XLon REAL,'
        'YLat REAL,'
        'YEAR INT,'
        'Class_Level1 INT,'
        'Class_Level2 INT,'
        'Class_Level3 INT'
    ')'
]

create_agro_sample_management_table_csv = [
    'CREATE TABLE AgroSampleCSV '
    '('
        'ID int primary key auto_increment,'
        'data_id INT,'
        'XLon REAL,'
        'YLat REAL,'
        'YEAR INT,'
        'DOY INT,'
        'MONTH INT,'
        'Class_Level1 INT,'
        'Class_Level2 INT,'
        'Class_Level3 INT,'
        'SampleSize INT'
    ')'
]

# create_agro_sample_management_table_csv = [
#     'CREATE TABLE AgroSampleCSV '
#     '('
#         'id bigint identity(1,1) not null PRIMARY key,'
#         'data_id INT,'
#         'XLon REAL,'
#         'YLat REAL,'
#         'YEAR INT,'
#         'DOY INT,'
#         'MONTH INT,'
#         'Class_Level1 INT,'
#         'Class_Level2 INT,'
#         'Class_Level3 INT,'
#         'SampleSize INT'
#     ')'
# ]

insert_data_into_tables = {
    "AgroSample": 'INSERT INTO AgroSample(XLon, YLat, YEAR, Class_Level1, Class_Level2, Class_Level3)'
    'VALUES (%f, %f, %d, %d, %d, %d)',
    "AgroSampleCSV": 'INSERT INTO AgroSampleCSV(data_id, XLon, YLat, YEAR, DOY, MONTH, Class_Level1, Class_Level2, Class_Level3, SampleSize)'
    'VALUES (%d, %f, %f, %d, %d, %d, %d, %d, %d, %d)',
}


